"yyyymmdd". DTOS()

    DTOS() converts a date value to a character string suitable for
    INDEXing in a compound key.

Syntax

    DTOS(<expD>)

Argument

    <expD> is the date value to convert.

Returns

    A character string.

    DTOS() returns a string eight characters long in the format "yyyymmdd".
    When <expD> evaluates to a null date, DTOS() returns a string of eight
    spaces.

Usage

    The intention of DTOS() is to facilitate the ease of creating index key
    expressions consisting of a date value and character expressions
    independent of DATE and CENTURY SETtings and preserving date order
    (year, month, and day).